package com.cuikaipeng.dao;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.cuikaipeng.entity.Company;
import com.cuikaipeng.entity.Tctype;

public interface CompanyDao {
	List<Company> list(Company company);
	@Select("SELECT * FROM company WHERE bh =#{id}")
	List<Company> getc(String id);
	@Select("SELECT * FROM tctype WHERE bh =#{id}")
	List<Tctype> gett(String id);
	@Select("SELECT * FROM company WHERE bh =#{id}")
	Company getcc(String id);
	@Insert("INSERT INTO tctype VALUES(#{hh},#{tcdate},#{wendu},#{sbtype},#{bh})")
	void add(Tctype t);
	@Delete("delete from tctype where hh=#{id}")
	Object del(@Param("id")Integer id);
	
	
}
